
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo.SP_SYS_USER_VALIDATE]
	@Login	nvarchar(50),
	@Hash	nvarchar(32)
AS
BEGIN
	select 1 from dbo.SYS_USER usr
	inner join dbo.SYS_USER_PASSWORD psw on (usr.USR_ID = psw.USR_ID)
	where usr.USR_LGN = @Login and psw.USR_PWD_VAL = @Hash	
END
GO